package monitora.bean;

import java.io.Serializable;
import java.sql.Date;

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.SequenceGenerator;
import javax.persistence.Table;

import org.hibernate.annotations.NamedNativeQueries;
import org.hibernate.annotations.NamedNativeQuery;

@Entity
@Table(name="TB_FORMULARIO1", schema="MONITORA")

@NamedNativeQueries({
	@NamedNativeQuery(
			name="formulario1", query="SELECT * FROM MONITORA.TB_FORMULARIO1", resultClass=Formulario1Bean.class),
	@NamedNativeQuery(
			name="formulario1_codigo", query="SELECT * FROM MONITORA.TB_FORMULARIO1 WHERE CD_PREFEITURA = :CODIGO", resultClass=Formulario1Bean.class),
	@NamedNativeQuery(
			name="formulario1_sem_arquivo", query="SELECT * FROM MONITORA.FORMULARIO1_SEM_ARQUIVO(:CODIGO)", resultClass=Formulario1Bean.class)
})
public class Formulario1Bean implements Serializable {

	@Id
	@SequenceGenerator(name="FORMULARIO1", sequenceName="MONITORA.SQ_FORMULARIO1")
	@GeneratedValue(generator="FORMULARIO1", strategy=GenerationType.AUTO)
	@Column(name="CD_FORMULARIO1")
	private int codigo;
	
	@Column(name="CD_PREFEITURA")
	private int codigoPrefeitura;
	
	@Column(name="Q1")
	private String q1;
	
	@Column(name="QN1")
	private String qn1;
	
	@Column(name="Q2")
	private Date q2;
	
	@Column(name="QA2N")
	private String qa2n;
	
	@Column(name="QA2")
	private byte[] qa2;
	
	@Column(name="Q3")
	private Date q3;
	
	@Column(name="QA3N")
	private String qa3n;
	
	@Column(name="QA3")
	private byte[] qa3;
	
	@Column(name="Q4")
	private String q4;
	
	@Column(name="QN41")
	private String qn41;
	
	@Column(name="QN42")
	private String qn42;
	
	@Column(name="QS41")
	private String qs41;
	
	@Column(name="QSN4")
	private String qsn4;
	
	@Column(name="QS42")
	private String qs42;
	
	@Column(name="Q5")
	private String q5;
	
	@Column(name="QN5")
	private String qn5;
	
	@Column(name="QS5N")
	private String qs5n;
	
	@Column(name="QS5")
	private byte[] qs5;
	
	@Column(name="Q6")
	private String q6;
	
	@Column(name="QS6N")
	private String qs6n;
	
	@Column(name="QS6")
	private byte[] qs6;
	
	@Column(name="Q7")
	private String q7;
	
	@Column(name="QS7N")
	private String qs7n;
	
	@Column(name="QS7")
	private byte[] qs7;
	
	@Column(name="QN71")
	private String qn71;
	
	@Column(name="QN72")
	private String qn72;
	
	@Column(name="Q8")
	private String q8;
	
	@Column(name="QS8N")
	private String qs8n;
	
	@Column(name="QS8")
	private byte[] qs8;
	
	@Column(name="QN8")
	private String qn8;
	
	@Column(name="Q9")
	private String q9;
	
	@Column(name="QS91")
	private Date qs91;
	
	@Column(name="QS92N")
	private String qs92n;
	
	@Column(name="QS92")
	private byte[] qs92;
	
	@Column(name="QN9")
	private String qn9;
	
	@Column(name="Q10")
	private String q10;
	
	@Column(name="QN10")
	private String qn10;
	
	@Column(name="Q11")
	private String q11;
	
	@Column(name="QS111")
	private Date qs111;
	
	@Column(name="QS112N")
	private String qs112n;
	
	@Column(name="QS112")
	private byte[] qs112;
	
	@Column(name="QN11")
	private String qn11;
	
	@Column(name="Q12")
	private String q12;
	
	@Column(name="QS121")
	private Date qs121;
	
	@Column(name="QS122N")
	private String qs122n;
	
	@Column(name="QS122")
	private byte[] qs122;
	
	@Column(name="QN12")
	private String qn12;
	
	@Column(name="Q13")
	private String q13;
	
	@Column(name="QS131")
	private Date qs131;
	
	@Column(name="QS132N")
	private String qs132n;
	
	@Column(name="Qs132")
	private byte[] qs132;
	
	@Column(name="QS133N")
	private String qs133n;
	
	@Column(name="QS133")
	private byte[] qs133;
	
	@Column(name="QN131")
	private String qn131;
	
	@Column(name="QN132")
	private String qn132;
	
	@Column(name="QN133")
	private String qn133;
	
	@Column(name="Q14")
	private String q14;
	
	@Column(name="QS141")
	private Date qs141;
	
	@Column(name="QS142N")
	private String qs142n;
	
	@Column(name="QS142")
	private byte[] qs142;
	
	@Column(name="QN14")
	private String qn14;

	public int getCodigo() {
		return codigo;
	}

	public void setCodigo(int codigo) {
		this.codigo = codigo;
	}

	public int getCodigoPrefeitura() {
		return codigoPrefeitura;
	}

	public void setCodigoPrefeitura(int codigoPrefeitura) {
		this.codigoPrefeitura = codigoPrefeitura;
	}

	public String getQ1() {
		return q1;
	}

	public void setQ1(String q1) {
		this.q1 = q1;
	}

	public String getQn1() {
		return qn1;
	}

	public void setQn1(String qn1) {
		this.qn1 = qn1;
	}

	public Date getQ2() {
		return q2;
	}
	
	public String getQ2t() {
		if (q2 != null) {
			java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.DEFAULT);
			return df.format(q2);
		}
		return "";
	}

	public void setQ2(Date q2) {
		this.q2 = q2;
	}

	public String getQa2n() {
		return qa2n;
	}

	public void setQa2n(String qa2n) {
		this.qa2n = qa2n;
	}

	public byte[] getQa2() {
		return qa2;
	}

	public void setQa2(byte[] qa2) {
		this.qa2 = qa2;
	}

	public Date getQ3() {
		return q3;
	}
	
	public String getQ3t() {
		if (q3 != null) {
			java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.DEFAULT);
			return df.format(q3);
		}
		return "";
	}

	public void setQ3(Date q3) {
		this.q3 = q3;
	}

	public String getQa3n() {
		return qa3n;
	}

	public void setQa3n(String qa3n) {
		this.qa3n = qa3n;
	}

	public byte[] getQa3() {
		return qa3;
	}

	public void setQa3(byte[] qa3) {
		this.qa3 = qa3;
	}

	public String getQ4() {
		return q4;
	}

	public void setQ4(String q4) {
		this.q4 = q4;
	}

	public String getQn41() {
		return qn41;
	}

	public void setQn41(String qn41) {
		this.qn41 = qn41;
	}

	public String getQn42() {
		return qn42;
	}

	public void setQn42(String qn42) {
		this.qn42 = qn42;
	}

	public String getQs41() {
		return qs41;
	}

	public void setQs41(String qs41) {
		this.qs41 = qs41;
	}

	public String getQsn4() {
		return qsn4;
	}

	public void setQsn4(String qsn4) {
		this.qsn4 = qsn4;
	}

	public String getQs42() {
		return qs42;
	}

	public void setQs42(String qs42) {
		this.qs42 = qs42;
	}

	public String getQ5() {
		return q5;
	}

	public void setQ5(String q5) {
		this.q5 = q5;
	}

	public String getQn5() {
		return qn5;
	}

	public void setQn5(String qn5) {
		this.qn5 = qn5;
	}

	public String getQs5n() {
		return qs5n;
	}

	public void setQs5n(String qs5n) {
		this.qs5n = qs5n;
	}

	public byte[] getQs5() {
		return qs5;
	}

	public void setQs5(byte[] qs5) {
		this.qs5 = qs5;
	}

	public String getQ6() {
		return q6;
	}

	public void setQ6(String q6) {
		this.q6 = q6;
	}

	public String getQs6n() {
		return qs6n;
	}

	public void setQs6n(String qs6n) {
		this.qs6n = qs6n;
	}

	public byte[] getQs6() {
		return qs6;
	}

	public void setQs6(byte[] qs6) {
		this.qs6 = qs6;
	}

	public String getQ7() {
		return q7;
	}

	public void setQ7(String q7) {
		this.q7 = q7;
	}

	public String getQs7n() {
		return qs7n;
	}

	public void setQs7n(String qs7n) {
		this.qs7n = qs7n;
	}

	public byte[] getQs7() {
		return qs7;
	}

	public void setQs7(byte[] qs7) {
		this.qs7 = qs7;
	}

	public String getQn71() {
		return qn71;
	}

	public void setQn71(String qn71) {
		this.qn71 = qn71;
	}

	public String getQn72() {
		return qn72;
	}

	public void setQn72(String qn72) {
		this.qn72 = qn72;
	}

	public String getQ8() {
		return q8;
	}

	public void setQ8(String q8) {
		this.q8 = q8;
	}

	public String getQs8n() {
		return qs8n;
	}

	public void setQs8n(String qs8n) {
		this.qs8n = qs8n;
	}

	public byte[] getQs8() {
		return qs8;
	}

	public void setQs8(byte[] qs8) {
		this.qs8 = qs8;
	}

	public String getQn8() {
		return qn8;
	}

	public void setQn8(String qn8) {
		this.qn8 = qn8;
	}

	public String getQ9() {
		return q9;
	}

	public void setQ9(String q9) {
		this.q9 = q9;
	}

	public Date getQs91() {
		return qs91;
	}
	
	public String getQs91t() {
		if (qs91 != null) {
			java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.DEFAULT);
			return df.format(qs91);
		}
		return "";
	}

	public void setQs91(Date qs91) {
		this.qs91 = qs91;
	}

	public String getQs92n() {
		return qs92n;
	}

	public void setQs92n(String qs92n) {
		this.qs92n = qs92n;
	}

	public byte[] getQs92() {
		return qs92;
	}

	public void setQs92(byte[] qs92) {
		this.qs92 = qs92;
	}

	public String getQn9() {
		return qn9;
	}

	public void setQn9(String qn9) {
		this.qn9 = qn9;
	}

	public String getQ10() {
		return q10;
	}

	public void setQ10(String q10) {
		this.q10 = q10;
	}

	public String getQn10() {
		return qn10;
	}

	public void setQn10(String qn10) {
		this.qn10 = qn10;
	}

	public String getQ11() {
		return q11;
	}

	public void setQ11(String q11) {
		this.q11 = q11;
	}

	public Date getQs111() {
		return qs111;
	}
	
	public String getQs111t() {
		if (qs111 != null) {
			java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.DEFAULT);
			return df.format(qs111);
		}
		return "";
	}

	public void setQs111(Date qs111) {
		this.qs111 = qs111;
	}

	public String getQs112n() {
		return qs112n;
	}

	public void setQs112n(String qs112n) {
		this.qs112n = qs112n;
	}

	public byte[] getQs112() {
		return qs112;
	}

	public void setQs112(byte[] qs112) {
		this.qs112 = qs112;
	}

	public String getQn11() {
		return qn11;
	}

	public void setQn11(String qn11) {
		this.qn11 = qn11;
	}

	public String getQ12() {
		return q12;
	}

	public void setQ12(String q12) {
		this.q12 = q12;
	}

	public Date getQs121() {
		return qs121;
	}
	
	public String getQs121t() {
		if (qs121 != null) {
			java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.DEFAULT);
			return df.format(qs121);
		}
		return "";
	}

	public void setQs121(Date qs121) {
		this.qs121 = qs121;
	}

	public String getQs122n() {
		return qs122n;
	}

	public void setQs122n(String qs122n) {
		this.qs122n = qs122n;
	}

	public byte[] getQs122() {
		return qs122;
	}

	public void setQs122(byte[] qs122) {
		this.qs122 = qs122;
	}

	public String getQn12() {
		return qn12;
	}

	public void setQn12(String qn12) {
		this.qn12 = qn12;
	}

	public String getQ13() {
		return q13;
	}

	public void setQ13(String q13) {
		this.q13 = q13;
	}

	public Date getQs131() {
		return qs131;
	}
	
	public String getQs131t() {
		if (qs131 != null) {
			java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.DEFAULT);
			return df.format(qs131);
		}
		return "";
	}

	public void setQs131(Date qs131) {
		this.qs131 = qs131;
	}

	public String getQs132n() {
		return qs132n;
	}

	public void setQs132n(String qs132n) {
		this.qs132n = qs132n;
	}

	public byte[] getQs132() {
		return qs132;
	}

	public void setQs132(byte[] qs132) {
		this.qs132 = qs132;
	}

	public String getQs133n() {
		return qs133n;
	}

	public void setQs133n(String qs133n) {
		this.qs133n = qs133n;
	}

	public byte[] getQs133() {
		return qs133;
	}

	public void setQs133(byte[] qs133) {
		this.qs133 = qs133;
	}

	public String getQn131() {
		return qn131;
	}

	public void setQn131(String qn131) {
		this.qn131 = qn131;
	}

	public String getQn132() {
		return qn132;
	}

	public void setQn132(String qn132) {
		this.qn132 = qn132;
	}

	public String getQn133() {
		return qn133;
	}

	public void setQn133(String qn133) {
		this.qn133 = qn133;
	}

	public String getQ14() {
		return q14;
	}

	public void setQ14(String q14) {
		this.q14 = q14;
	}

	public Date getQs141() {
		return qs141;
	}
	
	public String getQs141t() {
		if (qs141 != null) {
			java.text.DateFormat df = java.text.DateFormat.getDateInstance(java.text.DateFormat.DEFAULT);
			return df.format(qs141);
		}
		return "";
	}

	public void setQs141(Date qs141) {
		this.qs141 = qs141;
	}

	public String getQs142n() {
		return qs142n;
	}

	public void setQs142n(String qs142n) {
		this.qs142n = qs142n;
	}

	public byte[] getQs142() {
		return qs142;
	}

	public void setQs142(byte[] qs142) {
		this.qs142 = qs142;
	}

	public String getQn14() {
		return qn14;
	}

	public void setQn14(String qn14) {
		this.qn14 = qn14;
	}
	
}
